<style>
	.tinh tr td{
		padding:5px;
	}
	.t{
		font-size:15px;
		color:#016D3E;
	}
	.t1{
		text-align:center;
		font-weight:bold;
		color:#016D3E;
	}
</style>
<div id="gioithieu">
   	<div id="tieude_1">
  	<p>THÔNG TIN KHÁCH HÀNG </p>
</div>
	<div id="noidung_gt"> 
    	<?php
			if(isset($_SESSION['taikhoan'])) {
				$sql="SELECT * FROM qldl_khach_hang
  						where qldl_khach_hang.TEN_DN_TK = '{$_SESSION['taikhoan']}'";
				$list=$mysqli->query($sql);
				if(@$list->num_rows > 0){
					echo "<table border='1' cellpadding='0' cellspacing='0' width='100%' class='tinh'>";
					echo"<tr><th class='t1'>Họ tên</th>
						<th class='t1'>CMND/PASSPORT</th>
						<th class='t1'>Địa chỉ Email</th>
						<th class='t1'>Số điện thoại</th>
						<th class='t1'>Địa chỉ</th></tr>";
					while($row=$list->fetch_array()){
            			echo "<tr><td >$row[HO_TEN_TK]</td>";
						echo "<td >$row[CMND_PASSPORT_TK]</td>";
						echo "<td >$row[EMAIL_TK]</td>";
						echo "<td >$row[SO_DT_TK]</td>";
						echo "<td >$row[DIA_CHI_TK]</td>";
						echo "</tr>";
					}
					echo"</table>";
				}
			}
			else echo"Không tìm thấy thông tin khách hàng";
		?>
	</div>
</div>
               
<div id="gioithieu">
	<div id="tieude_1">
    <p>THÔNG TIN ĐẶT TOUR</p>
</div>
<div id="noidung_gt">
	<?php
		$list=$mysqli->query("SELECT * 
			FROM qldl_tour 
			inner join qldl_chi_tiet_dat_tour
			on qldl_tour.ma_tour=qldl_chi_tiet_dat_tour.ma_tour
			inner join qldl_khach_hang
			on qldl_chi_tiet_dat_tour.TEN_DN_TK=qldl_khach_hang.TEN_DN_TK
  			where qldl_khach_hang.TEN_DN_TK='".$_SESSION['taikhoan']."'");
		echo "<table border='1' cellpadding='0' cellspacing='0' width='100%'>";
		echo"<th class='t1'>Mã tour</th>
			<th class='t1'>Tên tour</th>
			<th class='t1'>Số người lớn</th>
			<th class='t1'>Số trẻ em</th>
			<th class='t1'>Thành tiền</th>
			<th class='t1'>Tình trạng</th>";			
		while($row=$list->fetch_array()){
			echo "<tr class='t' align='center' >";
			echo "<td >$row[MA_TOUR]</td>";
			echo "<td >$row[TEN_TOUR]</td>";
			echo "<td >$row[NGUOI_LON]</td>";
			echo "<td >$row[TRE_EM]</td>";
			echo "<td >";
			echo number_format($row['THANH_TIEN'],0,",",".");
			echo "</td>";
			if($row['XL_DAT_TOUR']==1)
				echo "<td style='color:#0000FF'>Đã xử lý</td>";
			else echo "<td style='color:#FF0000'>Chưa xử lý</td>";
			echo "</tr>";
		}
		echo"</table>";
	?>
    </div>
</div> 